package com.tramy.data.export.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.List;

public class TramygsLeagueExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TramygsLeagueExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andLeaguecodeIsNull() {
            addCriterion("LeagueCode is null");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeIsNotNull() {
            addCriterion("LeagueCode is not null");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeEqualTo(String value) {
            addCriterion("LeagueCode =", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeNotEqualTo(String value) {
            addCriterion("LeagueCode <>", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeGreaterThan(String value) {
            addCriterion("LeagueCode >", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeGreaterThanOrEqualTo(String value) {
            addCriterion("LeagueCode >=", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeLessThan(String value) {
            addCriterion("LeagueCode <", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeLessThanOrEqualTo(String value) {
            addCriterion("LeagueCode <=", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeLike(String value) {
            addCriterion("LeagueCode like", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeNotLike(String value) {
            addCriterion("LeagueCode not like", value, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeIn(List<String> values) {
            addCriterion("LeagueCode in", values, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeNotIn(List<String> values) {
            addCriterion("LeagueCode not in", values, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeBetween(String value1, String value2) {
            addCriterion("LeagueCode between", value1, value2, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguecodeNotBetween(String value1, String value2) {
            addCriterion("LeagueCode not between", value1, value2, "leaguecode");
            return (Criteria) this;
        }

        public Criteria andLeaguenameIsNull() {
            addCriterion("LeagueName is null");
            return (Criteria) this;
        }

        public Criteria andLeaguenameIsNotNull() {
            addCriterion("LeagueName is not null");
            return (Criteria) this;
        }

        public Criteria andLeaguenameEqualTo(String value) {
            addCriterion("LeagueName =", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameNotEqualTo(String value) {
            addCriterion("LeagueName <>", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameGreaterThan(String value) {
            addCriterion("LeagueName >", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameGreaterThanOrEqualTo(String value) {
            addCriterion("LeagueName >=", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameLessThan(String value) {
            addCriterion("LeagueName <", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameLessThanOrEqualTo(String value) {
            addCriterion("LeagueName <=", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameLike(String value) {
            addCriterion("LeagueName like", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameNotLike(String value) {
            addCriterion("LeagueName not like", value, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameIn(List<String> values) {
            addCriterion("LeagueName in", values, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameNotIn(List<String> values) {
            addCriterion("LeagueName not in", values, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameBetween(String value1, String value2) {
            addCriterion("LeagueName between", value1, value2, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguenameNotBetween(String value1, String value2) {
            addCriterion("LeagueName not between", value1, value2, "leaguename");
            return (Criteria) this;
        }

        public Criteria andLeaguedescIsNull() {
            addCriterion("LeagueDesc is null");
            return (Criteria) this;
        }

        public Criteria andLeaguedescIsNotNull() {
            addCriterion("LeagueDesc is not null");
            return (Criteria) this;
        }

        public Criteria andLeaguedescEqualTo(String value) {
            addCriterion("LeagueDesc =", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescNotEqualTo(String value) {
            addCriterion("LeagueDesc <>", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescGreaterThan(String value) {
            addCriterion("LeagueDesc >", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescGreaterThanOrEqualTo(String value) {
            addCriterion("LeagueDesc >=", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescLessThan(String value) {
            addCriterion("LeagueDesc <", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescLessThanOrEqualTo(String value) {
            addCriterion("LeagueDesc <=", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescLike(String value) {
            addCriterion("LeagueDesc like", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescNotLike(String value) {
            addCriterion("LeagueDesc not like", value, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescIn(List<String> values) {
            addCriterion("LeagueDesc in", values, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescNotIn(List<String> values) {
            addCriterion("LeagueDesc not in", values, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescBetween(String value1, String value2) {
            addCriterion("LeagueDesc between", value1, value2, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andLeaguedescNotBetween(String value1, String value2) {
            addCriterion("LeagueDesc not between", value1, value2, "leaguedesc");
            return (Criteria) this;
        }

        public Criteria andMnemonicIsNull() {
            addCriterion("Mnemonic is null");
            return (Criteria) this;
        }

        public Criteria andMnemonicIsNotNull() {
            addCriterion("Mnemonic is not null");
            return (Criteria) this;
        }

        public Criteria andMnemonicEqualTo(String value) {
            addCriterion("Mnemonic =", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicNotEqualTo(String value) {
            addCriterion("Mnemonic <>", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicGreaterThan(String value) {
            addCriterion("Mnemonic >", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicGreaterThanOrEqualTo(String value) {
            addCriterion("Mnemonic >=", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicLessThan(String value) {
            addCriterion("Mnemonic <", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicLessThanOrEqualTo(String value) {
            addCriterion("Mnemonic <=", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicLike(String value) {
            addCriterion("Mnemonic like", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicNotLike(String value) {
            addCriterion("Mnemonic not like", value, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicIn(List<String> values) {
            addCriterion("Mnemonic in", values, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicNotIn(List<String> values) {
            addCriterion("Mnemonic not in", values, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicBetween(String value1, String value2) {
            addCriterion("Mnemonic between", value1, value2, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andMnemonicNotBetween(String value1, String value2) {
            addCriterion("Mnemonic not between", value1, value2, "mnemonic");
            return (Criteria) this;
        }

        public Criteria andOldcodeIsNull() {
            addCriterion("OldCode is null");
            return (Criteria) this;
        }

        public Criteria andOldcodeIsNotNull() {
            addCriterion("OldCode is not null");
            return (Criteria) this;
        }

        public Criteria andOldcodeEqualTo(String value) {
            addCriterion("OldCode =", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeNotEqualTo(String value) {
            addCriterion("OldCode <>", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeGreaterThan(String value) {
            addCriterion("OldCode >", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeGreaterThanOrEqualTo(String value) {
            addCriterion("OldCode >=", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeLessThan(String value) {
            addCriterion("OldCode <", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeLessThanOrEqualTo(String value) {
            addCriterion("OldCode <=", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeLike(String value) {
            addCriterion("OldCode like", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeNotLike(String value) {
            addCriterion("OldCode not like", value, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeIn(List<String> values) {
            addCriterion("OldCode in", values, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeNotIn(List<String> values) {
            addCriterion("OldCode not in", values, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeBetween(String value1, String value2) {
            addCriterion("OldCode between", value1, value2, "oldcode");
            return (Criteria) this;
        }

        public Criteria andOldcodeNotBetween(String value1, String value2) {
            addCriterion("OldCode not between", value1, value2, "oldcode");
            return (Criteria) this;
        }

        public Criteria andTypecodeIsNull() {
            addCriterion("TypeCode is null");
            return (Criteria) this;
        }

        public Criteria andTypecodeIsNotNull() {
            addCriterion("TypeCode is not null");
            return (Criteria) this;
        }

        public Criteria andTypecodeEqualTo(String value) {
            addCriterion("TypeCode =", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeNotEqualTo(String value) {
            addCriterion("TypeCode <>", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeGreaterThan(String value) {
            addCriterion("TypeCode >", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeGreaterThanOrEqualTo(String value) {
            addCriterion("TypeCode >=", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeLessThan(String value) {
            addCriterion("TypeCode <", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeLessThanOrEqualTo(String value) {
            addCriterion("TypeCode <=", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeLike(String value) {
            addCriterion("TypeCode like", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeNotLike(String value) {
            addCriterion("TypeCode not like", value, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeIn(List<String> values) {
            addCriterion("TypeCode in", values, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeNotIn(List<String> values) {
            addCriterion("TypeCode not in", values, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeBetween(String value1, String value2) {
            addCriterion("TypeCode between", value1, value2, "typecode");
            return (Criteria) this;
        }

        public Criteria andTypecodeNotBetween(String value1, String value2) {
            addCriterion("TypeCode not between", value1, value2, "typecode");
            return (Criteria) this;
        }

        public Criteria andSortcodeIsNull() {
            addCriterion("SortCode is null");
            return (Criteria) this;
        }

        public Criteria andSortcodeIsNotNull() {
            addCriterion("SortCode is not null");
            return (Criteria) this;
        }

        public Criteria andSortcodeEqualTo(String value) {
            addCriterion("SortCode =", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeNotEqualTo(String value) {
            addCriterion("SortCode <>", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeGreaterThan(String value) {
            addCriterion("SortCode >", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeGreaterThanOrEqualTo(String value) {
            addCriterion("SortCode >=", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeLessThan(String value) {
            addCriterion("SortCode <", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeLessThanOrEqualTo(String value) {
            addCriterion("SortCode <=", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeLike(String value) {
            addCriterion("SortCode like", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeNotLike(String value) {
            addCriterion("SortCode not like", value, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeIn(List<String> values) {
            addCriterion("SortCode in", values, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeNotIn(List<String> values) {
            addCriterion("SortCode not in", values, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeBetween(String value1, String value2) {
            addCriterion("SortCode between", value1, value2, "sortcode");
            return (Criteria) this;
        }

        public Criteria andSortcodeNotBetween(String value1, String value2) {
            addCriterion("SortCode not between", value1, value2, "sortcode");
            return (Criteria) this;
        }

        public Criteria andGradecodeIsNull() {
            addCriterion("GradeCode is null");
            return (Criteria) this;
        }

        public Criteria andGradecodeIsNotNull() {
            addCriterion("GradeCode is not null");
            return (Criteria) this;
        }

        public Criteria andGradecodeEqualTo(String value) {
            addCriterion("GradeCode =", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeNotEqualTo(String value) {
            addCriterion("GradeCode <>", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeGreaterThan(String value) {
            addCriterion("GradeCode >", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeGreaterThanOrEqualTo(String value) {
            addCriterion("GradeCode >=", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeLessThan(String value) {
            addCriterion("GradeCode <", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeLessThanOrEqualTo(String value) {
            addCriterion("GradeCode <=", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeLike(String value) {
            addCriterion("GradeCode like", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeNotLike(String value) {
            addCriterion("GradeCode not like", value, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeIn(List<String> values) {
            addCriterion("GradeCode in", values, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeNotIn(List<String> values) {
            addCriterion("GradeCode not in", values, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeBetween(String value1, String value2) {
            addCriterion("GradeCode between", value1, value2, "gradecode");
            return (Criteria) this;
        }

        public Criteria andGradecodeNotBetween(String value1, String value2) {
            addCriterion("GradeCode not between", value1, value2, "gradecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeIsNull() {
            addCriterion("StateCode is null");
            return (Criteria) this;
        }

        public Criteria andStatecodeIsNotNull() {
            addCriterion("StateCode is not null");
            return (Criteria) this;
        }

        public Criteria andStatecodeEqualTo(String value) {
            addCriterion("StateCode =", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeNotEqualTo(String value) {
            addCriterion("StateCode <>", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeGreaterThan(String value) {
            addCriterion("StateCode >", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeGreaterThanOrEqualTo(String value) {
            addCriterion("StateCode >=", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeLessThan(String value) {
            addCriterion("StateCode <", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeLessThanOrEqualTo(String value) {
            addCriterion("StateCode <=", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeLike(String value) {
            addCriterion("StateCode like", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeNotLike(String value) {
            addCriterion("StateCode not like", value, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeIn(List<String> values) {
            addCriterion("StateCode in", values, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeNotIn(List<String> values) {
            addCriterion("StateCode not in", values, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeBetween(String value1, String value2) {
            addCriterion("StateCode between", value1, value2, "statecode");
            return (Criteria) this;
        }

        public Criteria andStatecodeNotBetween(String value1, String value2) {
            addCriterion("StateCode not between", value1, value2, "statecode");
            return (Criteria) this;
        }

        public Criteria andCitycodeIsNull() {
            addCriterion("CityCode is null");
            return (Criteria) this;
        }

        public Criteria andCitycodeIsNotNull() {
            addCriterion("CityCode is not null");
            return (Criteria) this;
        }

        public Criteria andCitycodeEqualTo(String value) {
            addCriterion("CityCode =", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotEqualTo(String value) {
            addCriterion("CityCode <>", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeGreaterThan(String value) {
            addCriterion("CityCode >", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeGreaterThanOrEqualTo(String value) {
            addCriterion("CityCode >=", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLessThan(String value) {
            addCriterion("CityCode <", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLessThanOrEqualTo(String value) {
            addCriterion("CityCode <=", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeLike(String value) {
            addCriterion("CityCode like", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotLike(String value) {
            addCriterion("CityCode not like", value, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeIn(List<String> values) {
            addCriterion("CityCode in", values, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotIn(List<String> values) {
            addCriterion("CityCode not in", values, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeBetween(String value1, String value2) {
            addCriterion("CityCode between", value1, value2, "citycode");
            return (Criteria) this;
        }

        public Criteria andCitycodeNotBetween(String value1, String value2) {
            addCriterion("CityCode not between", value1, value2, "citycode");
            return (Criteria) this;
        }

        public Criteria andCountyIsNull() {
            addCriterion("County is null");
            return (Criteria) this;
        }

        public Criteria andCountyIsNotNull() {
            addCriterion("County is not null");
            return (Criteria) this;
        }

        public Criteria andCountyEqualTo(String value) {
            addCriterion("County =", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotEqualTo(String value) {
            addCriterion("County <>", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThan(String value) {
            addCriterion("County >", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThanOrEqualTo(String value) {
            addCriterion("County >=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThan(String value) {
            addCriterion("County <", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThanOrEqualTo(String value) {
            addCriterion("County <=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLike(String value) {
            addCriterion("County like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotLike(String value) {
            addCriterion("County not like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyIn(List<String> values) {
            addCriterion("County in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotIn(List<String> values) {
            addCriterion("County not in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyBetween(String value1, String value2) {
            addCriterion("County between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotBetween(String value1, String value2) {
            addCriterion("County not between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("Address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("Address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("Address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("Address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("Address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("Address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("Address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("Address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("Address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("Address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("Address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("Address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("Address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("Address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andPastIsNull() {
            addCriterion("Past is null");
            return (Criteria) this;
        }

        public Criteria andPastIsNotNull() {
            addCriterion("Past is not null");
            return (Criteria) this;
        }

        public Criteria andPastEqualTo(String value) {
            addCriterion("Past =", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastNotEqualTo(String value) {
            addCriterion("Past <>", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastGreaterThan(String value) {
            addCriterion("Past >", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastGreaterThanOrEqualTo(String value) {
            addCriterion("Past >=", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastLessThan(String value) {
            addCriterion("Past <", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastLessThanOrEqualTo(String value) {
            addCriterion("Past <=", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastLike(String value) {
            addCriterion("Past like", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastNotLike(String value) {
            addCriterion("Past not like", value, "past");
            return (Criteria) this;
        }

        public Criteria andPastIn(List<String> values) {
            addCriterion("Past in", values, "past");
            return (Criteria) this;
        }

        public Criteria andPastNotIn(List<String> values) {
            addCriterion("Past not in", values, "past");
            return (Criteria) this;
        }

        public Criteria andPastBetween(String value1, String value2) {
            addCriterion("Past between", value1, value2, "past");
            return (Criteria) this;
        }

        public Criteria andPastNotBetween(String value1, String value2) {
            addCriterion("Past not between", value1, value2, "past");
            return (Criteria) this;
        }

        public Criteria andLinkmanIsNull() {
            addCriterion("LinkMan is null");
            return (Criteria) this;
        }

        public Criteria andLinkmanIsNotNull() {
            addCriterion("LinkMan is not null");
            return (Criteria) this;
        }

        public Criteria andLinkmanEqualTo(String value) {
            addCriterion("LinkMan =", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotEqualTo(String value) {
            addCriterion("LinkMan <>", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanGreaterThan(String value) {
            addCriterion("LinkMan >", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanGreaterThanOrEqualTo(String value) {
            addCriterion("LinkMan >=", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLessThan(String value) {
            addCriterion("LinkMan <", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLessThanOrEqualTo(String value) {
            addCriterion("LinkMan <=", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanLike(String value) {
            addCriterion("LinkMan like", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotLike(String value) {
            addCriterion("LinkMan not like", value, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanIn(List<String> values) {
            addCriterion("LinkMan in", values, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotIn(List<String> values) {
            addCriterion("LinkMan not in", values, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanBetween(String value1, String value2) {
            addCriterion("LinkMan between", value1, value2, "linkman");
            return (Criteria) this;
        }

        public Criteria andLinkmanNotBetween(String value1, String value2) {
            addCriterion("LinkMan not between", value1, value2, "linkman");
            return (Criteria) this;
        }

        public Criteria andCautionerIsNull() {
            addCriterion("Cautioner is null");
            return (Criteria) this;
        }

        public Criteria andCautionerIsNotNull() {
            addCriterion("Cautioner is not null");
            return (Criteria) this;
        }

        public Criteria andCautionerEqualTo(String value) {
            addCriterion("Cautioner =", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerNotEqualTo(String value) {
            addCriterion("Cautioner <>", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerGreaterThan(String value) {
            addCriterion("Cautioner >", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerGreaterThanOrEqualTo(String value) {
            addCriterion("Cautioner >=", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerLessThan(String value) {
            addCriterion("Cautioner <", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerLessThanOrEqualTo(String value) {
            addCriterion("Cautioner <=", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerLike(String value) {
            addCriterion("Cautioner like", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerNotLike(String value) {
            addCriterion("Cautioner not like", value, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerIn(List<String> values) {
            addCriterion("Cautioner in", values, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerNotIn(List<String> values) {
            addCriterion("Cautioner not in", values, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerBetween(String value1, String value2) {
            addCriterion("Cautioner between", value1, value2, "cautioner");
            return (Criteria) this;
        }

        public Criteria andCautionerNotBetween(String value1, String value2) {
            addCriterion("Cautioner not between", value1, value2, "cautioner");
            return (Criteria) this;
        }

        public Criteria andHandsetIsNull() {
            addCriterion("Handset is null");
            return (Criteria) this;
        }

        public Criteria andHandsetIsNotNull() {
            addCriterion("Handset is not null");
            return (Criteria) this;
        }

        public Criteria andHandsetEqualTo(String value) {
            addCriterion("Handset =", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetNotEqualTo(String value) {
            addCriterion("Handset <>", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetGreaterThan(String value) {
            addCriterion("Handset >", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetGreaterThanOrEqualTo(String value) {
            addCriterion("Handset >=", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetLessThan(String value) {
            addCriterion("Handset <", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetLessThanOrEqualTo(String value) {
            addCriterion("Handset <=", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetLike(String value) {
            addCriterion("Handset like", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetNotLike(String value) {
            addCriterion("Handset not like", value, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetIn(List<String> values) {
            addCriterion("Handset in", values, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetNotIn(List<String> values) {
            addCriterion("Handset not in", values, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetBetween(String value1, String value2) {
            addCriterion("Handset between", value1, value2, "handset");
            return (Criteria) this;
        }

        public Criteria andHandsetNotBetween(String value1, String value2) {
            addCriterion("Handset not between", value1, value2, "handset");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("Phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("Phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("Phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("Phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("Phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("Phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("Phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("Phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("Phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("Phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("Phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("Phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("Phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("Phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andFaxIsNull() {
            addCriterion("Fax is null");
            return (Criteria) this;
        }

        public Criteria andFaxIsNotNull() {
            addCriterion("Fax is not null");
            return (Criteria) this;
        }

        public Criteria andFaxEqualTo(String value) {
            addCriterion("Fax =", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotEqualTo(String value) {
            addCriterion("Fax <>", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThan(String value) {
            addCriterion("Fax >", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxGreaterThanOrEqualTo(String value) {
            addCriterion("Fax >=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThan(String value) {
            addCriterion("Fax <", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLessThanOrEqualTo(String value) {
            addCriterion("Fax <=", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxLike(String value) {
            addCriterion("Fax like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotLike(String value) {
            addCriterion("Fax not like", value, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxIn(List<String> values) {
            addCriterion("Fax in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotIn(List<String> values) {
            addCriterion("Fax not in", values, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxBetween(String value1, String value2) {
            addCriterion("Fax between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andFaxNotBetween(String value1, String value2) {
            addCriterion("Fax not between", value1, value2, "fax");
            return (Criteria) this;
        }

        public Criteria andEmailIsNull() {
            addCriterion("Email is null");
            return (Criteria) this;
        }

        public Criteria andEmailIsNotNull() {
            addCriterion("Email is not null");
            return (Criteria) this;
        }

        public Criteria andEmailEqualTo(String value) {
            addCriterion("Email =", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotEqualTo(String value) {
            addCriterion("Email <>", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThan(String value) {
            addCriterion("Email >", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailGreaterThanOrEqualTo(String value) {
            addCriterion("Email >=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThan(String value) {
            addCriterion("Email <", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLessThanOrEqualTo(String value) {
            addCriterion("Email <=", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailLike(String value) {
            addCriterion("Email like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotLike(String value) {
            addCriterion("Email not like", value, "email");
            return (Criteria) this;
        }

        public Criteria andEmailIn(List<String> values) {
            addCriterion("Email in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotIn(List<String> values) {
            addCriterion("Email not in", values, "email");
            return (Criteria) this;
        }

        public Criteria andEmailBetween(String value1, String value2) {
            addCriterion("Email between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andEmailNotBetween(String value1, String value2) {
            addCriterion("Email not between", value1, value2, "email");
            return (Criteria) this;
        }

        public Criteria andImIsNull() {
            addCriterion("IM is null");
            return (Criteria) this;
        }

        public Criteria andImIsNotNull() {
            addCriterion("IM is not null");
            return (Criteria) this;
        }

        public Criteria andImEqualTo(String value) {
            addCriterion("IM =", value, "im");
            return (Criteria) this;
        }

        public Criteria andImNotEqualTo(String value) {
            addCriterion("IM <>", value, "im");
            return (Criteria) this;
        }

        public Criteria andImGreaterThan(String value) {
            addCriterion("IM >", value, "im");
            return (Criteria) this;
        }

        public Criteria andImGreaterThanOrEqualTo(String value) {
            addCriterion("IM >=", value, "im");
            return (Criteria) this;
        }

        public Criteria andImLessThan(String value) {
            addCriterion("IM <", value, "im");
            return (Criteria) this;
        }

        public Criteria andImLessThanOrEqualTo(String value) {
            addCriterion("IM <=", value, "im");
            return (Criteria) this;
        }

        public Criteria andImLike(String value) {
            addCriterion("IM like", value, "im");
            return (Criteria) this;
        }

        public Criteria andImNotLike(String value) {
            addCriterion("IM not like", value, "im");
            return (Criteria) this;
        }

        public Criteria andImIn(List<String> values) {
            addCriterion("IM in", values, "im");
            return (Criteria) this;
        }

        public Criteria andImNotIn(List<String> values) {
            addCriterion("IM not in", values, "im");
            return (Criteria) this;
        }

        public Criteria andImBetween(String value1, String value2) {
            addCriterion("IM between", value1, value2, "im");
            return (Criteria) this;
        }

        public Criteria andImNotBetween(String value1, String value2) {
            addCriterion("IM not between", value1, value2, "im");
            return (Criteria) this;
        }

        public Criteria andCyclecodeIsNull() {
            addCriterion("CycleCode is null");
            return (Criteria) this;
        }

        public Criteria andCyclecodeIsNotNull() {
            addCriterion("CycleCode is not null");
            return (Criteria) this;
        }

        public Criteria andCyclecodeEqualTo(String value) {
            addCriterion("CycleCode =", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeNotEqualTo(String value) {
            addCriterion("CycleCode <>", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeGreaterThan(String value) {
            addCriterion("CycleCode >", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeGreaterThanOrEqualTo(String value) {
            addCriterion("CycleCode >=", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeLessThan(String value) {
            addCriterion("CycleCode <", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeLessThanOrEqualTo(String value) {
            addCriterion("CycleCode <=", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeLike(String value) {
            addCriterion("CycleCode like", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeNotLike(String value) {
            addCriterion("CycleCode not like", value, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeIn(List<String> values) {
            addCriterion("CycleCode in", values, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeNotIn(List<String> values) {
            addCriterion("CycleCode not in", values, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeBetween(String value1, String value2) {
            addCriterion("CycleCode between", value1, value2, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCyclecodeNotBetween(String value1, String value2) {
            addCriterion("CycleCode not between", value1, value2, "cyclecode");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionIsNull() {
            addCriterion("CheckDescription is null");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionIsNotNull() {
            addCriterion("CheckDescription is not null");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionEqualTo(String value) {
            addCriterion("CheckDescription =", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionNotEqualTo(String value) {
            addCriterion("CheckDescription <>", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionGreaterThan(String value) {
            addCriterion("CheckDescription >", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionGreaterThanOrEqualTo(String value) {
            addCriterion("CheckDescription >=", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionLessThan(String value) {
            addCriterion("CheckDescription <", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionLessThanOrEqualTo(String value) {
            addCriterion("CheckDescription <=", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionLike(String value) {
            addCriterion("CheckDescription like", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionNotLike(String value) {
            addCriterion("CheckDescription not like", value, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionIn(List<String> values) {
            addCriterion("CheckDescription in", values, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionNotIn(List<String> values) {
            addCriterion("CheckDescription not in", values, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionBetween(String value1, String value2) {
            addCriterion("CheckDescription between", value1, value2, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andCheckdescriptionNotBetween(String value1, String value2) {
            addCriterion("CheckDescription not between", value1, value2, "checkdescription");
            return (Criteria) this;
        }

        public Criteria andAccountdayIsNull() {
            addCriterion("AccountDay is null");
            return (Criteria) this;
        }

        public Criteria andAccountdayIsNotNull() {
            addCriterion("AccountDay is not null");
            return (Criteria) this;
        }

        public Criteria andAccountdayEqualTo(Integer value) {
            addCriterion("AccountDay =", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayNotEqualTo(Integer value) {
            addCriterion("AccountDay <>", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayGreaterThan(Integer value) {
            addCriterion("AccountDay >", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayGreaterThanOrEqualTo(Integer value) {
            addCriterion("AccountDay >=", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayLessThan(Integer value) {
            addCriterion("AccountDay <", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayLessThanOrEqualTo(Integer value) {
            addCriterion("AccountDay <=", value, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayIn(List<Integer> values) {
            addCriterion("AccountDay in", values, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayNotIn(List<Integer> values) {
            addCriterion("AccountDay not in", values, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayBetween(Integer value1, Integer value2) {
            addCriterion("AccountDay between", value1, value2, "accountday");
            return (Criteria) this;
        }

        public Criteria andAccountdayNotBetween(Integer value1, Integer value2) {
            addCriterion("AccountDay not between", value1, value2, "accountday");
            return (Criteria) this;
        }

        public Criteria andIsadvanceIsNull() {
            addCriterion("IsAdvance is null");
            return (Criteria) this;
        }

        public Criteria andIsadvanceIsNotNull() {
            addCriterion("IsAdvance is not null");
            return (Criteria) this;
        }

        public Criteria andIsadvanceEqualTo(Integer value) {
            addCriterion("IsAdvance =", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceNotEqualTo(Integer value) {
            addCriterion("IsAdvance <>", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceGreaterThan(Integer value) {
            addCriterion("IsAdvance >", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsAdvance >=", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceLessThan(Integer value) {
            addCriterion("IsAdvance <", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceLessThanOrEqualTo(Integer value) {
            addCriterion("IsAdvance <=", value, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceIn(List<Integer> values) {
            addCriterion("IsAdvance in", values, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceNotIn(List<Integer> values) {
            addCriterion("IsAdvance not in", values, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceBetween(Integer value1, Integer value2) {
            addCriterion("IsAdvance between", value1, value2, "isadvance");
            return (Criteria) this;
        }

        public Criteria andIsadvanceNotBetween(Integer value1, Integer value2) {
            addCriterion("IsAdvance not between", value1, value2, "isadvance");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsIsNull() {
            addCriterion("Prepayments is null");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsIsNotNull() {
            addCriterion("Prepayments is not null");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsEqualTo(BigDecimal value) {
            addCriterion("Prepayments =", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsNotEqualTo(BigDecimal value) {
            addCriterion("Prepayments <>", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsGreaterThan(BigDecimal value) {
            addCriterion("Prepayments >", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("Prepayments >=", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsLessThan(BigDecimal value) {
            addCriterion("Prepayments <", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsLessThanOrEqualTo(BigDecimal value) {
            addCriterion("Prepayments <=", value, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsIn(List<BigDecimal> values) {
            addCriterion("Prepayments in", values, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsNotIn(List<BigDecimal> values) {
            addCriterion("Prepayments not in", values, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Prepayments between", value1, value2, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPrepaymentsNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("Prepayments not between", value1, value2, "prepayments");
            return (Criteria) this;
        }

        public Criteria andPressuregoldIsNull() {
            addCriterion("PressureGold is null");
            return (Criteria) this;
        }

        public Criteria andPressuregoldIsNotNull() {
            addCriterion("PressureGold is not null");
            return (Criteria) this;
        }

        public Criteria andPressuregoldEqualTo(BigDecimal value) {
            addCriterion("PressureGold =", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldNotEqualTo(BigDecimal value) {
            addCriterion("PressureGold <>", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldGreaterThan(BigDecimal value) {
            addCriterion("PressureGold >", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("PressureGold >=", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldLessThan(BigDecimal value) {
            addCriterion("PressureGold <", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldLessThanOrEqualTo(BigDecimal value) {
            addCriterion("PressureGold <=", value, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldIn(List<BigDecimal> values) {
            addCriterion("PressureGold in", values, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldNotIn(List<BigDecimal> values) {
            addCriterion("PressureGold not in", values, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PressureGold between", value1, value2, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andPressuregoldNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("PressureGold not between", value1, value2, "pressuregold");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceIsNull() {
            addCriterion("KingInterface is null");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceIsNotNull() {
            addCriterion("KingInterface is not null");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceEqualTo(String value) {
            addCriterion("KingInterface =", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceNotEqualTo(String value) {
            addCriterion("KingInterface <>", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceGreaterThan(String value) {
            addCriterion("KingInterface >", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceGreaterThanOrEqualTo(String value) {
            addCriterion("KingInterface >=", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceLessThan(String value) {
            addCriterion("KingInterface <", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceLessThanOrEqualTo(String value) {
            addCriterion("KingInterface <=", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceLike(String value) {
            addCriterion("KingInterface like", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceNotLike(String value) {
            addCriterion("KingInterface not like", value, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceIn(List<String> values) {
            addCriterion("KingInterface in", values, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceNotIn(List<String> values) {
            addCriterion("KingInterface not in", values, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceBetween(String value1, String value2) {
            addCriterion("KingInterface between", value1, value2, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andKinginterfaceNotBetween(String value1, String value2) {
            addCriterion("KingInterface not between", value1, value2, "kinginterface");
            return (Criteria) this;
        }

        public Criteria andOpenaccountIsNull() {
            addCriterion("OpenAccount is null");
            return (Criteria) this;
        }

        public Criteria andOpenaccountIsNotNull() {
            addCriterion("OpenAccount is not null");
            return (Criteria) this;
        }

        public Criteria andOpenaccountEqualTo(String value) {
            addCriterion("OpenAccount =", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountNotEqualTo(String value) {
            addCriterion("OpenAccount <>", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountGreaterThan(String value) {
            addCriterion("OpenAccount >", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountGreaterThanOrEqualTo(String value) {
            addCriterion("OpenAccount >=", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountLessThan(String value) {
            addCriterion("OpenAccount <", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountLessThanOrEqualTo(String value) {
            addCriterion("OpenAccount <=", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountLike(String value) {
            addCriterion("OpenAccount like", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountNotLike(String value) {
            addCriterion("OpenAccount not like", value, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountIn(List<String> values) {
            addCriterion("OpenAccount in", values, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountNotIn(List<String> values) {
            addCriterion("OpenAccount not in", values, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountBetween(String value1, String value2) {
            addCriterion("OpenAccount between", value1, value2, "openaccount");
            return (Criteria) this;
        }

        public Criteria andOpenaccountNotBetween(String value1, String value2) {
            addCriterion("OpenAccount not between", value1, value2, "openaccount");
            return (Criteria) this;
        }

        public Criteria andBankcardIsNull() {
            addCriterion("BankCard is null");
            return (Criteria) this;
        }

        public Criteria andBankcardIsNotNull() {
            addCriterion("BankCard is not null");
            return (Criteria) this;
        }

        public Criteria andBankcardEqualTo(String value) {
            addCriterion("BankCard =", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotEqualTo(String value) {
            addCriterion("BankCard <>", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardGreaterThan(String value) {
            addCriterion("BankCard >", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardGreaterThanOrEqualTo(String value) {
            addCriterion("BankCard >=", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLessThan(String value) {
            addCriterion("BankCard <", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLessThanOrEqualTo(String value) {
            addCriterion("BankCard <=", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardLike(String value) {
            addCriterion("BankCard like", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotLike(String value) {
            addCriterion("BankCard not like", value, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardIn(List<String> values) {
            addCriterion("BankCard in", values, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotIn(List<String> values) {
            addCriterion("BankCard not in", values, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardBetween(String value1, String value2) {
            addCriterion("BankCard between", value1, value2, "bankcard");
            return (Criteria) this;
        }

        public Criteria andBankcardNotBetween(String value1, String value2) {
            addCriterion("BankCard not between", value1, value2, "bankcard");
            return (Criteria) this;
        }

        public Criteria andAccountsnameIsNull() {
            addCriterion("AccountsName is null");
            return (Criteria) this;
        }

        public Criteria andAccountsnameIsNotNull() {
            addCriterion("AccountsName is not null");
            return (Criteria) this;
        }

        public Criteria andAccountsnameEqualTo(String value) {
            addCriterion("AccountsName =", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameNotEqualTo(String value) {
            addCriterion("AccountsName <>", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameGreaterThan(String value) {
            addCriterion("AccountsName >", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameGreaterThanOrEqualTo(String value) {
            addCriterion("AccountsName >=", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameLessThan(String value) {
            addCriterion("AccountsName <", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameLessThanOrEqualTo(String value) {
            addCriterion("AccountsName <=", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameLike(String value) {
            addCriterion("AccountsName like", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameNotLike(String value) {
            addCriterion("AccountsName not like", value, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameIn(List<String> values) {
            addCriterion("AccountsName in", values, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameNotIn(List<String> values) {
            addCriterion("AccountsName not in", values, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameBetween(String value1, String value2) {
            addCriterion("AccountsName between", value1, value2, "accountsname");
            return (Criteria) this;
        }

        public Criteria andAccountsnameNotBetween(String value1, String value2) {
            addCriterion("AccountsName not between", value1, value2, "accountsname");
            return (Criteria) this;
        }

        public Criteria andTaxcodeIsNull() {
            addCriterion("TaxCode is null");
            return (Criteria) this;
        }

        public Criteria andTaxcodeIsNotNull() {
            addCriterion("TaxCode is not null");
            return (Criteria) this;
        }

        public Criteria andTaxcodeEqualTo(String value) {
            addCriterion("TaxCode =", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeNotEqualTo(String value) {
            addCriterion("TaxCode <>", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeGreaterThan(String value) {
            addCriterion("TaxCode >", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeGreaterThanOrEqualTo(String value) {
            addCriterion("TaxCode >=", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeLessThan(String value) {
            addCriterion("TaxCode <", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeLessThanOrEqualTo(String value) {
            addCriterion("TaxCode <=", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeLike(String value) {
            addCriterion("TaxCode like", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeNotLike(String value) {
            addCriterion("TaxCode not like", value, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeIn(List<String> values) {
            addCriterion("TaxCode in", values, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeNotIn(List<String> values) {
            addCriterion("TaxCode not in", values, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeBetween(String value1, String value2) {
            addCriterion("TaxCode between", value1, value2, "taxcode");
            return (Criteria) this;
        }

        public Criteria andTaxcodeNotBetween(String value1, String value2) {
            addCriterion("TaxCode not between", value1, value2, "taxcode");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitIsNull() {
            addCriterion("MoneyUpperLimit is null");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitIsNotNull() {
            addCriterion("MoneyUpperLimit is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitEqualTo(BigDecimal value) {
            addCriterion("MoneyUpperLimit =", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitNotEqualTo(BigDecimal value) {
            addCriterion("MoneyUpperLimit <>", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitGreaterThan(BigDecimal value) {
            addCriterion("MoneyUpperLimit >", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MoneyUpperLimit >=", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitLessThan(BigDecimal value) {
            addCriterion("MoneyUpperLimit <", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MoneyUpperLimit <=", value, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitIn(List<BigDecimal> values) {
            addCriterion("MoneyUpperLimit in", values, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitNotIn(List<BigDecimal> values) {
            addCriterion("MoneyUpperLimit not in", values, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MoneyUpperLimit between", value1, value2, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneyupperlimitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MoneyUpperLimit not between", value1, value2, "moneyupperlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitIsNull() {
            addCriterion("MoneyLowerLimit is null");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitIsNotNull() {
            addCriterion("MoneyLowerLimit is not null");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitEqualTo(BigDecimal value) {
            addCriterion("MoneyLowerLimit =", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitNotEqualTo(BigDecimal value) {
            addCriterion("MoneyLowerLimit <>", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitGreaterThan(BigDecimal value) {
            addCriterion("MoneyLowerLimit >", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("MoneyLowerLimit >=", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitLessThan(BigDecimal value) {
            addCriterion("MoneyLowerLimit <", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitLessThanOrEqualTo(BigDecimal value) {
            addCriterion("MoneyLowerLimit <=", value, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitIn(List<BigDecimal> values) {
            addCriterion("MoneyLowerLimit in", values, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitNotIn(List<BigDecimal> values) {
            addCriterion("MoneyLowerLimit not in", values, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MoneyLowerLimit between", value1, value2, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andMoneylowerlimitNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("MoneyLowerLimit not between", value1, value2, "moneylowerlimit");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyIsNull() {
            addCriterion("HonourMoney is null");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyIsNotNull() {
            addCriterion("HonourMoney is not null");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyEqualTo(BigDecimal value) {
            addCriterion("HonourMoney =", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyNotEqualTo(BigDecimal value) {
            addCriterion("HonourMoney <>", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyGreaterThan(BigDecimal value) {
            addCriterion("HonourMoney >", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourMoney >=", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyLessThan(BigDecimal value) {
            addCriterion("HonourMoney <", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourMoney <=", value, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyIn(List<BigDecimal> values) {
            addCriterion("HonourMoney in", values, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyNotIn(List<BigDecimal> values) {
            addCriterion("HonourMoney not in", values, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourMoney between", value1, value2, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonourmoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourMoney not between", value1, value2, "honourmoney");
            return (Criteria) this;
        }

        public Criteria andHonoursavingIsNull() {
            addCriterion("HonourSaving is null");
            return (Criteria) this;
        }

        public Criteria andHonoursavingIsNotNull() {
            addCriterion("HonourSaving is not null");
            return (Criteria) this;
        }

        public Criteria andHonoursavingEqualTo(BigDecimal value) {
            addCriterion("HonourSaving =", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingNotEqualTo(BigDecimal value) {
            addCriterion("HonourSaving <>", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingGreaterThan(BigDecimal value) {
            addCriterion("HonourSaving >", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourSaving >=", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingLessThan(BigDecimal value) {
            addCriterion("HonourSaving <", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourSaving <=", value, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingIn(List<BigDecimal> values) {
            addCriterion("HonourSaving in", values, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingNotIn(List<BigDecimal> values) {
            addCriterion("HonourSaving not in", values, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourSaving between", value1, value2, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonoursavingNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourSaving not between", value1, value2, "honoursaving");
            return (Criteria) this;
        }

        public Criteria andHonourintegralIsNull() {
            addCriterion("HonourIntegral is null");
            return (Criteria) this;
        }

        public Criteria andHonourintegralIsNotNull() {
            addCriterion("HonourIntegral is not null");
            return (Criteria) this;
        }

        public Criteria andHonourintegralEqualTo(BigDecimal value) {
            addCriterion("HonourIntegral =", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralNotEqualTo(BigDecimal value) {
            addCriterion("HonourIntegral <>", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralGreaterThan(BigDecimal value) {
            addCriterion("HonourIntegral >", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourIntegral >=", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralLessThan(BigDecimal value) {
            addCriterion("HonourIntegral <", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourIntegral <=", value, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralIn(List<BigDecimal> values) {
            addCriterion("HonourIntegral in", values, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralNotIn(List<BigDecimal> values) {
            addCriterion("HonourIntegral not in", values, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourIntegral between", value1, value2, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourintegralNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourIntegral not between", value1, value2, "honourintegral");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceIsNull() {
            addCriterion("HonourBalance is null");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceIsNotNull() {
            addCriterion("HonourBalance is not null");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceEqualTo(BigDecimal value) {
            addCriterion("HonourBalance =", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceNotEqualTo(BigDecimal value) {
            addCriterion("HonourBalance <>", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceGreaterThan(BigDecimal value) {
            addCriterion("HonourBalance >", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourBalance >=", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceLessThan(BigDecimal value) {
            addCriterion("HonourBalance <", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("HonourBalance <=", value, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceIn(List<BigDecimal> values) {
            addCriterion("HonourBalance in", values, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceNotIn(List<BigDecimal> values) {
            addCriterion("HonourBalance not in", values, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourBalance between", value1, value2, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andHonourbalanceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("HonourBalance not between", value1, value2, "honourbalance");
            return (Criteria) this;
        }

        public Criteria andFoundIsNull() {
            addCriterion("Found is null");
            return (Criteria) this;
        }

        public Criteria andFoundIsNotNull() {
            addCriterion("Found is not null");
            return (Criteria) this;
        }

        public Criteria andFoundEqualTo(String value) {
            addCriterion("Found =", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundNotEqualTo(String value) {
            addCriterion("Found <>", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundGreaterThan(String value) {
            addCriterion("Found >", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundGreaterThanOrEqualTo(String value) {
            addCriterion("Found >=", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundLessThan(String value) {
            addCriterion("Found <", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundLessThanOrEqualTo(String value) {
            addCriterion("Found <=", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundLike(String value) {
            addCriterion("Found like", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundNotLike(String value) {
            addCriterion("Found not like", value, "found");
            return (Criteria) this;
        }

        public Criteria andFoundIn(List<String> values) {
            addCriterion("Found in", values, "found");
            return (Criteria) this;
        }

        public Criteria andFoundNotIn(List<String> values) {
            addCriterion("Found not in", values, "found");
            return (Criteria) this;
        }

        public Criteria andFoundBetween(String value1, String value2) {
            addCriterion("Found between", value1, value2, "found");
            return (Criteria) this;
        }

        public Criteria andFoundNotBetween(String value1, String value2) {
            addCriterion("Found not between", value1, value2, "found");
            return (Criteria) this;
        }

        public Criteria andFounddateIsNull() {
            addCriterion("FoundDate is null");
            return (Criteria) this;
        }

        public Criteria andFounddateIsNotNull() {
            addCriterion("FoundDate is not null");
            return (Criteria) this;
        }

        public Criteria andFounddateEqualTo(String value) {
            addCriterion("FoundDate =", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateNotEqualTo(String value) {
            addCriterion("FoundDate <>", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateGreaterThan(String value) {
            addCriterion("FoundDate >", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateGreaterThanOrEqualTo(String value) {
            addCriterion("FoundDate >=", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateLessThan(String value) {
            addCriterion("FoundDate <", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateLessThanOrEqualTo(String value) {
            addCriterion("FoundDate <=", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateLike(String value) {
            addCriterion("FoundDate like", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateNotLike(String value) {
            addCriterion("FoundDate not like", value, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateIn(List<String> values) {
            addCriterion("FoundDate in", values, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateNotIn(List<String> values) {
            addCriterion("FoundDate not in", values, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateBetween(String value1, String value2) {
            addCriterion("FoundDate between", value1, value2, "founddate");
            return (Criteria) this;
        }

        public Criteria andFounddateNotBetween(String value1, String value2) {
            addCriterion("FoundDate not between", value1, value2, "founddate");
            return (Criteria) this;
        }

        public Criteria andModificationIsNull() {
            addCriterion("Modification is null");
            return (Criteria) this;
        }

        public Criteria andModificationIsNotNull() {
            addCriterion("Modification is not null");
            return (Criteria) this;
        }

        public Criteria andModificationEqualTo(String value) {
            addCriterion("Modification =", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationNotEqualTo(String value) {
            addCriterion("Modification <>", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationGreaterThan(String value) {
            addCriterion("Modification >", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationGreaterThanOrEqualTo(String value) {
            addCriterion("Modification >=", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationLessThan(String value) {
            addCriterion("Modification <", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationLessThanOrEqualTo(String value) {
            addCriterion("Modification <=", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationLike(String value) {
            addCriterion("Modification like", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationNotLike(String value) {
            addCriterion("Modification not like", value, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationIn(List<String> values) {
            addCriterion("Modification in", values, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationNotIn(List<String> values) {
            addCriterion("Modification not in", values, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationBetween(String value1, String value2) {
            addCriterion("Modification between", value1, value2, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationNotBetween(String value1, String value2) {
            addCriterion("Modification not between", value1, value2, "modification");
            return (Criteria) this;
        }

        public Criteria andModificationdateIsNull() {
            addCriterion("ModificationDate is null");
            return (Criteria) this;
        }

        public Criteria andModificationdateIsNotNull() {
            addCriterion("ModificationDate is not null");
            return (Criteria) this;
        }

        public Criteria andModificationdateEqualTo(String value) {
            addCriterion("ModificationDate =", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateNotEqualTo(String value) {
            addCriterion("ModificationDate <>", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateGreaterThan(String value) {
            addCriterion("ModificationDate >", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateGreaterThanOrEqualTo(String value) {
            addCriterion("ModificationDate >=", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateLessThan(String value) {
            addCriterion("ModificationDate <", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateLessThanOrEqualTo(String value) {
            addCriterion("ModificationDate <=", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateLike(String value) {
            addCriterion("ModificationDate like", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateNotLike(String value) {
            addCriterion("ModificationDate not like", value, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateIn(List<String> values) {
            addCriterion("ModificationDate in", values, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateNotIn(List<String> values) {
            addCriterion("ModificationDate not in", values, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateBetween(String value1, String value2) {
            addCriterion("ModificationDate between", value1, value2, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andModificationdateNotBetween(String value1, String value2) {
            addCriterion("ModificationDate not between", value1, value2, "modificationdate");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andIntypeIsNull() {
            addCriterion("INType is null");
            return (Criteria) this;
        }

        public Criteria andIntypeIsNotNull() {
            addCriterion("INType is not null");
            return (Criteria) this;
        }

        public Criteria andIntypeEqualTo(String value) {
            addCriterion("INType =", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeNotEqualTo(String value) {
            addCriterion("INType <>", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeGreaterThan(String value) {
            addCriterion("INType >", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeGreaterThanOrEqualTo(String value) {
            addCriterion("INType >=", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeLessThan(String value) {
            addCriterion("INType <", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeLessThanOrEqualTo(String value) {
            addCriterion("INType <=", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeLike(String value) {
            addCriterion("INType like", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeNotLike(String value) {
            addCriterion("INType not like", value, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeIn(List<String> values) {
            addCriterion("INType in", values, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeNotIn(List<String> values) {
            addCriterion("INType not in", values, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeBetween(String value1, String value2) {
            addCriterion("INType between", value1, value2, "intype");
            return (Criteria) this;
        }

        public Criteria andIntypeNotBetween(String value1, String value2) {
            addCriterion("INType not between", value1, value2, "intype");
            return (Criteria) this;
        }

        public Criteria andPcnameIsNull() {
            addCriterion("PCName is null");
            return (Criteria) this;
        }

        public Criteria andPcnameIsNotNull() {
            addCriterion("PCName is not null");
            return (Criteria) this;
        }

        public Criteria andPcnameEqualTo(String value) {
            addCriterion("PCName =", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameNotEqualTo(String value) {
            addCriterion("PCName <>", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameGreaterThan(String value) {
            addCriterion("PCName >", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameGreaterThanOrEqualTo(String value) {
            addCriterion("PCName >=", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameLessThan(String value) {
            addCriterion("PCName <", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameLessThanOrEqualTo(String value) {
            addCriterion("PCName <=", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameLike(String value) {
            addCriterion("PCName like", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameNotLike(String value) {
            addCriterion("PCName not like", value, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameIn(List<String> values) {
            addCriterion("PCName in", values, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameNotIn(List<String> values) {
            addCriterion("PCName not in", values, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameBetween(String value1, String value2) {
            addCriterion("PCName between", value1, value2, "pcname");
            return (Criteria) this;
        }

        public Criteria andPcnameNotBetween(String value1, String value2) {
            addCriterion("PCName not between", value1, value2, "pcname");
            return (Criteria) this;
        }

        public Criteria andSysIdIsNull() {
            addCriterion("sys_id is null");
            return (Criteria) this;
        }

        public Criteria andSysIdIsNotNull() {
            addCriterion("sys_id is not null");
            return (Criteria) this;
        }

        public Criteria andSysIdEqualTo(String value) {
            addCriterion("sys_id =", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotEqualTo(String value) {
            addCriterion("sys_id <>", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdGreaterThan(String value) {
            addCriterion("sys_id >", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdGreaterThanOrEqualTo(String value) {
            addCriterion("sys_id >=", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLessThan(String value) {
            addCriterion("sys_id <", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLessThanOrEqualTo(String value) {
            addCriterion("sys_id <=", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdLike(String value) {
            addCriterion("sys_id like", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotLike(String value) {
            addCriterion("sys_id not like", value, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdIn(List<String> values) {
            addCriterion("sys_id in", values, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotIn(List<String> values) {
            addCriterion("sys_id not in", values, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdBetween(String value1, String value2) {
            addCriterion("sys_id between", value1, value2, "sysId");
            return (Criteria) this;
        }

        public Criteria andSysIdNotBetween(String value1, String value2) {
            addCriterion("sys_id not between", value1, value2, "sysId");
            return (Criteria) this;
        }

        public Criteria andSeriaNumIsNull() {
            addCriterion("seria_num is null");
            return (Criteria) this;
        }

        public Criteria andSeriaNumIsNotNull() {
            addCriterion("seria_num is not null");
            return (Criteria) this;
        }

        public Criteria andSeriaNumEqualTo(Integer value) {
            addCriterion("seria_num =", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumNotEqualTo(Integer value) {
            addCriterion("seria_num <>", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumGreaterThan(Integer value) {
            addCriterion("seria_num >", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumGreaterThanOrEqualTo(Integer value) {
            addCriterion("seria_num >=", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumLessThan(Integer value) {
            addCriterion("seria_num <", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumLessThanOrEqualTo(Integer value) {
            addCriterion("seria_num <=", value, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumIn(List<Integer> values) {
            addCriterion("seria_num in", values, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumNotIn(List<Integer> values) {
            addCriterion("seria_num not in", values, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumBetween(Integer value1, Integer value2) {
            addCriterion("seria_num between", value1, value2, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andSeriaNumNotBetween(Integer value1, Integer value2) {
            addCriterion("seria_num not between", value1, value2, "seriaNum");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIsNull() {
            addCriterion("work_time is null");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIsNotNull() {
            addCriterion("work_time is not null");
            return (Criteria) this;
        }

        public Criteria andWorkTimeEqualTo(String value) {
            addCriterion("work_time =", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotEqualTo(String value) {
            addCriterion("work_time <>", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeGreaterThan(String value) {
            addCriterion("work_time >", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeGreaterThanOrEqualTo(String value) {
            addCriterion("work_time >=", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeLessThan(String value) {
            addCriterion("work_time <", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeLessThanOrEqualTo(String value) {
            addCriterion("work_time <=", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeLike(String value) {
            addCriterion("work_time like", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotLike(String value) {
            addCriterion("work_time not like", value, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeIn(List<String> values) {
            addCriterion("work_time in", values, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotIn(List<String> values) {
            addCriterion("work_time not in", values, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeBetween(String value1, String value2) {
            addCriterion("work_time between", value1, value2, "workTime");
            return (Criteria) this;
        }

        public Criteria andWorkTimeNotBetween(String value1, String value2) {
            addCriterion("work_time not between", value1, value2, "workTime");
            return (Criteria) this;
        }

        public Criteria andDocumentNumIsNull() {
            addCriterion("document_num is null");
            return (Criteria) this;
        }

        public Criteria andDocumentNumIsNotNull() {
            addCriterion("document_num is not null");
            return (Criteria) this;
        }

        public Criteria andDocumentNumEqualTo(String value) {
            addCriterion("document_num =", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumNotEqualTo(String value) {
            addCriterion("document_num <>", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumGreaterThan(String value) {
            addCriterion("document_num >", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumGreaterThanOrEqualTo(String value) {
            addCriterion("document_num >=", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumLessThan(String value) {
            addCriterion("document_num <", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumLessThanOrEqualTo(String value) {
            addCriterion("document_num <=", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumLike(String value) {
            addCriterion("document_num like", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumNotLike(String value) {
            addCriterion("document_num not like", value, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumIn(List<String> values) {
            addCriterion("document_num in", values, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumNotIn(List<String> values) {
            addCriterion("document_num not in", values, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumBetween(String value1, String value2) {
            addCriterion("document_num between", value1, value2, "documentNum");
            return (Criteria) this;
        }

        public Criteria andDocumentNumNotBetween(String value1, String value2) {
            addCriterion("document_num not between", value1, value2, "documentNum");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNull() {
            addCriterion("operator_id is null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIsNotNull() {
            addCriterion("operator_id is not null");
            return (Criteria) this;
        }

        public Criteria andOperatorIdEqualTo(String value) {
            addCriterion("operator_id =", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotEqualTo(String value) {
            addCriterion("operator_id <>", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThan(String value) {
            addCriterion("operator_id >", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(String value) {
            addCriterion("operator_id >=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThan(String value) {
            addCriterion("operator_id <", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLessThanOrEqualTo(String value) {
            addCriterion("operator_id <=", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdLike(String value) {
            addCriterion("operator_id like", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotLike(String value) {
            addCriterion("operator_id not like", value, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdIn(List<String> values) {
            addCriterion("operator_id in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotIn(List<String> values) {
            addCriterion("operator_id not in", values, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdBetween(String value1, String value2) {
            addCriterion("operator_id between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andOperatorIdNotBetween(String value1, String value2) {
            addCriterion("operator_id not between", value1, value2, "operatorId");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateIsNull() {
            addCriterion("issuance_date is null");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateIsNotNull() {
            addCriterion("issuance_date is not null");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateEqualTo(String value) {
            addCriterion("issuance_date =", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateNotEqualTo(String value) {
            addCriterion("issuance_date <>", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateGreaterThan(String value) {
            addCriterion("issuance_date >", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateGreaterThanOrEqualTo(String value) {
            addCriterion("issuance_date >=", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateLessThan(String value) {
            addCriterion("issuance_date <", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateLessThanOrEqualTo(String value) {
            addCriterion("issuance_date <=", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateLike(String value) {
            addCriterion("issuance_date like", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateNotLike(String value) {
            addCriterion("issuance_date not like", value, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateIn(List<String> values) {
            addCriterion("issuance_date in", values, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateNotIn(List<String> values) {
            addCriterion("issuance_date not in", values, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateBetween(String value1, String value2) {
            addCriterion("issuance_date between", value1, value2, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andIssuanceDateNotBetween(String value1, String value2) {
            addCriterion("issuance_date not between", value1, value2, "issuanceDate");
            return (Criteria) this;
        }

        public Criteria andActualDateIsNull() {
            addCriterion("actual_date is null");
            return (Criteria) this;
        }

        public Criteria andActualDateIsNotNull() {
            addCriterion("actual_date is not null");
            return (Criteria) this;
        }

        public Criteria andActualDateEqualTo(String value) {
            addCriterion("actual_date =", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateNotEqualTo(String value) {
            addCriterion("actual_date <>", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateGreaterThan(String value) {
            addCriterion("actual_date >", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateGreaterThanOrEqualTo(String value) {
            addCriterion("actual_date >=", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateLessThan(String value) {
            addCriterion("actual_date <", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateLessThanOrEqualTo(String value) {
            addCriterion("actual_date <=", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateLike(String value) {
            addCriterion("actual_date like", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateNotLike(String value) {
            addCriterion("actual_date not like", value, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateIn(List<String> values) {
            addCriterion("actual_date in", values, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateNotIn(List<String> values) {
            addCriterion("actual_date not in", values, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateBetween(String value1, String value2) {
            addCriterion("actual_date between", value1, value2, "actualDate");
            return (Criteria) this;
        }

        public Criteria andActualDateNotBetween(String value1, String value2) {
            addCriterion("actual_date not between", value1, value2, "actualDate");
            return (Criteria) this;
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}